<?php
###############   COPYLEFT GPLv3 LICENSE   ###############
##
## JFX Version 0.2.7
## Website Management Software
## www.jfxcms.com
##
## Copyright 2009 GPLv3 - http://www.opensource.org/licenses/gpl-3.0.html
##
## Anthony Gallon
## oi_antz@hotmail.com
##
## Permission is hereby granted to any person having a copy of this software
## to freely use and modify as required so long as the copyright notices
## and branding remain intact.
##
## Full license details available at http://www.jfxcms.com/license
##
###############   COPYLEFT GPLv3 LICENSE   ################

$packages = $DB->fetchAll("SELECT * FROM {$CONFIG->dbprefix}vms_packages ORDER BY keyname ASC");

foreach($packages as $k=>$v){
    $packages[$k]['title'] = $this->getContentLang('package_title', $v['id']);
    $packages[$k]['current_version'] = $VM->getCurrentVersion($v['id']);
    $vData = $DB->fetchRow("SELECT * FROM {$CONFIG->dbprefix}vms_versions WHERE package_id = '{$v['id']}' AND version = '{$packages[$k]['current_version']}'");

    $versions = $DB->fetchAll("SELECT * FROM {$CONFIG->dbprefix}vms_versions WHERE package_id = '{$v['id']}' ORDER BY version DESC");
    if(!is_array($versions)) $versions = array();
    $packages[$k]['version_history'] = $versions;

    if(is_array($vData) && count($vData)>0){
        $groups = $DB->fetchAll("SELECT * FROM {$CONFIG->dbprefix}vms_versions_to_groups WHERE package_id = '{$v['id']}' AND version_id = '{$vData['id']}'");
        foreach($groups as $key=>$value){
            $groups[$key]['title'] = $DB->oneValue($CONFIG->dbprefix.'iusers_groups', 'title', "keyname = '{$value['group_key']}'");
        }
        $packages[$k]['group_access'] = $groups;
    }
}





$SMARTY->assign('packages', $packages);

echo $this->fetchTemplate('default.tpl');










